SELECT     cin.CalendarItem_Note_ID, cin.CalendarItem_ID, cin.Sort, cin.Type_ID, cin.Type_Name, cin.Note_ID, cin.GUID, NN.Note
FROM         dbo.CalendarItem_Note AS cin LEFT OUTER JOIN
                      dbo.Note AS NN ON NN.Note_ID = cin.Note_ID